Columns of data might not appear in non-Listing ODS output when using an ACROSS variable in PROC REPORT with the NOCOMPLETECOLS option.

To circumvent the problem, remove the NOCOMPLETECOLS option. In situations where the removal of this option produces unwanted empty columns, add the NOZERO option to the DEFINE statement for the ACROSS variable.

The sample code on the Full Code tab generates an RTF file that illustrates the problem, and an RTF file that demonstrates the workarounds. An example of both RTF files can be opened from the Results tab.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	z/OS	9.2 TS1M0	9.3 TS1M2
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.2 TS1M0	9.3 TS1M2
		Microsoft Windows Server 2003 Datacenter 64-bit Edition	9.2 TS1M0	9.3 TS1M2
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	9.2 TS1M0	9.3 TS1M2
		Microsoft Windows XP 64-bit Edition	9.2 TS1M0	9.3 TS1M2
		Microsoft® Windows® for x64	9.2 TS1M0	9.3 TS1M2
		Microsoft Windows Server 2003 Datacenter Edition	9.2 TS1M0	9.3 TS1M2
		Microsoft Windows Server 2003 Enterprise Edition	9.2 TS1M0	9.3 TS1M2
		Microsoft Windows Server 2003 Standard Edition	9.2 TS1M0	9.3 TS1M2
		Microsoft Windows XP Professional	9.2 TS1M0	9.3 TS1M2
		Windows Vista	9.2 TS1M0	9.3 TS1M2
		Windows Vista for x64	9.2 TS1M0	9.3 TS1M2
		64-bit Enabled AIX	9.2 TS1M0	9.3 TS1M2
		64-bit Enabled HP-UX	9.2 TS1M0	9.3 TS1M2
		64-bit Enabled Solaris	9.2 TS1M0	9.3 TS1M2
		HP-UX IPF	9.2 TS1M0	9.3 TS1M2
		Linux	9.2 TS1M0	9.3 TS1M2
		Linux for x64	9.2 TS1M0	9.3 TS1M2
		OpenVMS on HP Integrity	9.2 TS1M0	9.3 TS1M2
		Solaris for x64	9.2 TS1M0	9.3 TS1M2

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

The sample code below generates RTF files that illustrate the problem, and demonstrate the workarounds. Both RTF files can be opened from the Results tab.

---

/* The Wagon column appears in the Listing (Output) window but not in the RTF file. */
ods rtf file='test1.rtf';

proc report data=sashelp.cars(obs=30) nowd nocompletecols;
   column make type, invoice dummy;
   define make / group;
   define type / across;
   define invoice / display;
   define dummy / noprint;
run;

ods rtf close;

/* With the circumventions, the Wagon column now appears in */
/* both the Listing (Output) window and in the RTF file.    */
ods rtf file='test2.rtf';

proc report data=sashelp.cars(obs=30) nowd ;
   column make type, invoice dummy;
   define make / group;
   define type / across nozero;
   define invoice / display;
   define dummy / noprint;
run;

ods rtf close;

RTF file demonstrating the missing column

RTF file containing all columns

Columns of data might be missing from non-Listing ODS output when using an ACROSS variable in PROC REPORT with the NOCOMPLETECOLS option.

Type:	Problem Note
Priority:	high

Date Modified:	2019-09-16 13:12:57
Date Created:	2012-01-27 16:32:11